As the Data Integration Analyst, you will be supporting the growth of Granular Insurance by performing data ingestion and analysis functions on projects and processes within the company. These include operational and project-based work in support of Granular’s insurance customers and partners. This may include reviewing healthcare data, file specifications, data reporting and dashboard development, and working on technical and operational projects in varying degrees of the project life cycle; from ideation, planning, execution, and maintenance. You will also help administer systems and processes within Granular, including Google Cloud Platform, BigQuery data management and SQL processing. You will develop, manage, and support ETL functions related to the intake of partner data files. You will also be working with a number of key stakeholders including company management, development partners, staff members, as well as the Verily technology teams supporting Granular.

To succeed in this role, you will need experience in healthcare data and in building, fixing, and monitoring/maintaining systems and processes in support of that data. You will need to be able to work at a strategic level and in the details. You will need to feel comfortable working in a “start-up” environment where processes and systems still need to be defined and built. Understanding the data about our business is very important and you will need to be familiar with data definitions, analytics, and reporting.

Responsibilities

• Collaborate with cross-functional teams at Granular to meet project goals as a participant.
• Familiarize yourself with healthcare data file structures in support of claims, diagnosis, procedures, and payments.
• Develop, troubleshoot, and maintain existing ETL processes for intake of partner healthcare data files. This includes interaction with and management of source code, new code development related to job specific functions, deployment and testing procedures, and production monitoring.
• External data provider contact communications to troubleshoot and reconcile data file interruptions, changes, and issues that arise.
• Administer data and data systems within multiple platforms including Google Cloud Platform, BigQuery data management and operations, Salesforce, Google Workspace, Reporting applications, and other systems as needed.

Qualifications

Minimum Qualifications:

• Undergraduate degree (BA/BS).
• 2 years of experience in data management, systems analysis, and/or project management, preferably within health insurance or technology.
• Excellent communication skills (oral and written), analytical and presentation skills with outstanding attention to detail and ability to take initiative, build productive relationships and influence effectively across various levels of stakeholders.
• Strong data, reporting, and application skills.
• Strong interpersonal skills with sensitivity to changing personalities and priorities.

Preferred Qualifications:

• Experience in building solutions, including Salesforce.com, SQL management, Reporting systems.
• Experience in building cloud-based software solutions.
• Experience managing and responding to help desk requests.
• Experience in managing data ETL processes and data reporting.
• Strong analytical thinking and problem-solving skills.